<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Mitglieder.master" CodeBehind="mitglied_uebersicht.aspx.vb" Inherits="PMS_Linq.mitglied_uebersicht" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder3" runat="server">
    <p>
        <br />
    </p>
    <asp:GridView ID="gv_Mitguebersicht" runat="server" Height="170px" 
        HorizontalAlign="Center" Width="607px" AllowSorting="True" 
          onselectedindexchanged = "bla"
        style="margin-left: 0px" AllowPaging="True" 
        DataSourceID="SqlDataSource1" AutoGenerateColumns="False" 
        EnableModelValidation="True" PageSize="300">
        <RowStyle HorizontalAlign="Center" />
        <Columns>
            <asp:CommandField SelectText="Details" ShowCancelButton="False" 
                ShowSelectButton="True" />
            <asp:BoundField DataField="Nachname" HeaderText="Nachname" ReadOnly="True" 
                SortExpression="Nachname" />
            <asp:BoundField DataField="Vorname" HeaderText="Vorname" ReadOnly="True" 
                SortExpression="Vorname" />
            <asp:BoundField DataField="Telefon" HeaderText="Telefon" ReadOnly="True" 
                SortExpression="Telefon" />
            <asp:BoundField DataField="Email" HeaderText="Email" ReadOnly="True" 
                SortExpression="Email" />
            <asp:BoundField DataField="Skype" HeaderText="Skype" ReadOnly="True" 
                SortExpression="Skype" />
            <asp:BoundField DataField="Status" HeaderText="Status" ReadOnly="True" 
                SortExpression="Status" />
            <asp:CheckBoxField DataField="aktiv" HeaderText="aktiv" 
                SortExpression="aktiv" />
        </Columns>
        <HeaderStyle HorizontalAlign="Center" />
     
    </asp:GridView>
    
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:PMSConnectionString %>" 
        
        
        SelectCommand="SELECT Nachname, Vorname, telefon AS Telefon, Email_HC AS Email, Skype, Mitgliedsstatus AS Status, Aktiv_passiv AS aktiv FROM Mitgliede_Anwaerter ORDER BY Nachname, Vorname"></asp:SqlDataSource>
    
    <p>
        &nbsp;</p>
    <p>
    </p>
    <p>
    </p>
    <p>
    </p>
    <p>
    </p>
</asp:Content>